www.loanperformer.com

Table of Contents (Online Help)

Import Chart of Accounts

This feature allows you to import your Charts of Accounts from other applications into Loan Performer. However you will have to arrange your data in an excel file format before importing can be done on Loan Performer.

Note that:
• The importation is only possible if no transactions have been posted into the General Ledger.
•Make sure that you have filled-out the importation templates correctly.

•The information you intend to import should be transferable / converted to the formats of dBase, Microsoft Excel or Tab delimited text files to make it possible to import into Loan performer.

• Link GL accounts numbers to their respective products.

• Define your Cash Accounts and Bank accounts.

• The template is arranged in a logical order so during data importation process, make sure that you follow the logical order.

• Do not reformat the templates to make them suit your own data format. i.e. do not add, modify or delete a column in any of these templates as these changes would make Loan Performer reject the affected template.

• When importing LPF disregards the first row (the headers) so you can change the column headers to something more descriptive.

• Each importation template has been filled with sample data to help you understand how you should fill them out. You therefore have to replace this data with your own.

• Do not leave empty rows, otherwise LPF will import data upto the end of the rows (Empty row) and will exclude the remaining data.

• Pay attention to date fields. The date and months fields should be represented by two digits while the months should be represented by four digits, e.g., "01/02/2019" . You have to pay particular attention to the date format, noting that the date format in the template should be changed to match the date format that you set at System/Configuration/General.

• If LPF requires a number as a character string, e.g., "Voucher No.", enter this with an apostrophe like ‘ or make sure the alignment is on the left side.

How to Import the Chart of Accounts

To import the Chart of Accounts you go to System/Configurations/Accounting/Import Chart of Accounts and a screen like the one below shows up.

• Files of type: Specify the import file type in the files of type: box, e.g., "Microsoft Excel File".
• Import file: Double click on the this field to browse for the file from a specified location / full path to the file that should be imported, e.g., "C:\LPF817\External Files\Import": Alternatively click on the Choose command button to browse for the file from a specified location.
• Error File: Specify the name of the file to which any errors encountered during the importation will be written,e.g., "Client.txt". By default it is stored in the Lpf working folder with the name Accounts.txt.
• Import file format: This scroll window lists the various fields of the file to be imported and their properties. These fields are already created in the Client.xls template that is found in the import folder that comes along with the Lpf installation or you can download them from http://www.loanperformer.com/Download/import.rar
• Imported Files: This scroll window lists all previously imported files. The details of imported transactions that have been imported will be shown under the column headings; File Name, Size, Date, Time Imported and User only if the Importation is successful.
• View: This button opens the selected import file and enables you to edit it within the corresponding application. You will be able to look at the Chart of accounts that are going to be imported. This enables you to ensure that the right data has been selected.
• Cancel: If for some reason you are not sure you want to proceed with the importation click on this command button to terminate the process.
• Reset: When you click on this command button, the imported file log will be cleared but doesn't cancel the already imported files.
• When all the necessary details have been entered into the importation template and saved the template is then ready for importation.
• Import: Click on this button to import the chart of accounts. The following validation message appears. Click "Yes" to import the chart of accounts.

The following validations will be performed on the importation data:

• Every Account should have a Parent Account Number. If the Account has no Parent Account, in case of, for instance, Assets or Liabilities, 0 should be entered as the value for the parent account number in the template.
• The width of the account number should be the width specified in "Width of the GL Account No." on Configuration Accounts screen;
• The Account Types should be 1, 2, 3 or 4 for the UK/US Chart of Accounts and 1, 2, 3, or 4 for BCEAO/PARMEC Chart of Accounts.

Related Topics

Contact LPF live support for more information
This service requires an Internet connection.